﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_UPDMS_CRD_ITEM_BIZ_Get_Checked_Map_Info')
	BEGIN
		DROP Procedure usp_UPDMS_CRD_ITEM_BIZ_Get_Checked_Map_Info
	END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
**	Name : usp_UPDMS_CRD_ITEM_BIZ_Get_Checked_Map_Info
**	Desc : 카드사용내역중 확인이 체크된 내역의 장소정보를 조회
**	Test Exec Query : Exec usp_UPDMS_CRD_ITEM_BIZ_Get_Checked_Map_Info
**	Called by : Global.cs
**	Program ID : NaverMapEx
**	Auth : 송시명
**	Date : 2014-01-22
*******************************************************************************
**	Change History
*******************************************************************************
**	Date:		Author:		Description:
**	--------	--------	---------------------------------------
**	
*******************************************************************************/
CREATE PROC [dbo].[usp_UPDMS_CRD_ITEM_BIZ_Get_Checked_Map_Info]
AS
SET NOCOUNT OFF

SELECT '---SELECT---' AS [Text],
       '300068|543252' AS [Value],
	   0 AS View_Order
UNION
SELECT Contents,
       Latitude + '|' + Longitude,
	   1
  FROM UPDMS_CRD_ITEM_BIZ WITH(NOLOCK)
 WHERE ISNULL(Latitude, '') <> ''
   AND ISNULL(Longitude, '') <> ''
   AND Check_Yn = 'Y'
 ORDER BY View_Order, [Text]

GO